<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Auto text codes for datasets</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
table.whs1 { x-cell-content-align:top; border-spacing:0px; }
tr.whs2 { x-cell-content-align:top; height:25px; }
td.whs3 { border-left-width:1px; border-left-color:#000000; border-left-style:Solid; border-top-style:Solid; border-top-color:#000000; border-top-width:1px; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
p.whs4 { font-weight:bold; }
td.whs5 { border-top-style:Solid; border-top-color:#000000; border-top-width:1px; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
tr.whs6 { x-cell-content-align:top; height:84px; }
td.whs7 { border-left-width:1px; border-left-color:#000000; border-left-style:Solid; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
td.whs8 { border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
tr.whs9 { x-cell-content-align:top; height:231px; }
tr.whs10 { x-cell-content-align:top; height:357px; }
p.whs11 { margin-top:0pt; margin-bottom:0pt; }
tr.whs12 { x-cell-content-align:top; height:62px; }
p.whs13 { margin-bottom:0pt; }
tr.whs14 { x-cell-content-align:top; height:24px; }
p.whs15 { margin-left:40px; }
p.whs16 { margin-left:0px; }
ul.whs17 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs11 {margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs13 {margin-bottom:1pt; }";
  strNSS += "p.whs16 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating and formatting a document\nAdding and editing text and data in a document\nAdding auto text codes to documents\nAuto text codes for datasets");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Auto text codes for datasets</h1>
<p>The following auto text codes allow you to add dataset information to 
 your document. For all these codes, replace <span class=Code style="font-style: italic;"><I>REPORTNAME</I></span> 
 with the name of the related dataset report. If the name contains any 
 spaces or special characters, type the name within square brackets [ ]. 
 For example, for a report named <span class=Code>Sales Forecast</span>, 
 type<span class=Code> {&amp;[Sales Forecast]:}</span>. Special characters 
 are defined as anything other than a-z, A-Z, #, _, . (period), and 0-9.</p>
<table x-use-null-cells cellspacing="0" class="whs1">
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table><table x-use-null-cells cellspacing='0' border='1' bordercolor='black' bordercolorlight='black' bordercolordark='black'>");
//--></script>
<col>
<col>
<col>
<col>


<tr valign="top" class="whs2">
<td class="whs3">
<p class="whs4">Description</td>
<td class="whs5">
<p class="whs4">Code</td>
<td class="whs5">
<p class="whs4">Sample Output</td>
<td class="whs5">
<p class="whs4">Comments</td></tr>

<tr valign="top" class="whs6">
<td class="whs7">
<p>Dataset report description</td>
<td class="whs8">
<p>{&amp;REPORTNAME:DESCRIPTION}</td>
<td class="whs8">
<p>Revenue, profit, &amp; cost by employee &amp; region</td>
<td class="whs8">
<p>The short description of the specified dataset report. If the report 
 does not have a description, the text field remains blank. </td></tr>

<tr valign="top" class="whs9">
<td class="whs7">
<p>Dataset report details</td>
<td class="whs8">
<p>{&amp;REPORTNAME:REPORTDETAILS}</td>
<td class="whs8">
<p>Report Description: </p>
<p>Revenue, profit, &amp; cost by region &amp; employee</p>
<p>Report Filter: (2007)</p>
<p>Filter for Year = 2007</p>
<p>Year = 2007</p>
<p>Report Limits: Revenue &gt; 2000000</p>
<p>Template: Region, Employee</p>
<p>Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+}</td>
<td class="whs8">
<p>The complete report details, including report description, prompt details, 
 filter details, and template details of the specified dataset report. 
 </p>
<p>You can define how this auto text code is displayed (for example, if 
 the report description is shown). </td></tr>

<tr valign="top" class="whs10">
<td class="whs7">
<p>Dataset report filter and limit details</td>
<td class="whs8">
<p>{&amp;REPORTNAME: FILTERDETAILS}</p>
<p>- or -</p>
<p>{&amp;FILTERDETAILS}</td>
<td class="whs8">
<p>If the filter in the dataset's Filter editor is defined as:</p>
<p class="whs11">A=1</p>
<p class="whs11">AND</p>
<p class="whs11">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B=2</p>
<p class="whs11">&nbsp;&nbsp;&nbsp;OR</p>
<p class="whs11">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C=3</p>
<p>it prints as: </p>
<p>A=1 and (B=2 or C=3)</p>
<p>For example, Region=South and (Year=2002 or Year=2003)</td>
<td class="whs8">
<p>The report filter and report limit used in the dataset report. An example 
 is {&amp;[Sales Forecast]: FILTERDETAILS} for the Sales Forecast report.</p>
<p>If the dataset report has a report filter and a report limit, the system 
 displays <span style="font-weight: bold;"><B>or</B></span> between them. If there 
 is no filter, <span style="font-weight: bold;"><B>Empty Filter</B></span> is 
 displayed. If there is no limit, <span style="font-weight: bold;"><B>Empty 
 Limit</B></span> is displayed.</p>
<p>If you do not specify the report’s REPORTNAME as part of the code, the 
 filter and limit information from the document’s grouping and sorting 
 dataset is printed.</p>
<p>By default, only the report filter and report limit are displayed, but 
 other filters, such as view filters and security filters, can be displayed 
 as well. </td></tr>

<tr valign="top" class="whs12">
<td class="whs7">
<p>Dataset report prompt details</td>
<td class="whs8">
<p>{&amp;REPORTNAME:</p>
<p>PROMPTDETAILS} </td>
<td class="whs8">
<p class="whs13">Prompt 1: Region prompt</p>
<p class="whs13">Northwest, Southwest</p>
<p class="whs13">Prompt 2: Year</p>
<p class="whs13">Year (ID)= 2007</td>
<td class="whs8">
<p>The prompt information for all prompts in the specified dataset report. 
 </p>
<p>You can define how this auto text code is displayed (for example, if 
 the prompt name is shown).</td></tr>

<tr valign="top" class="whs14">
<td class="whs7">
<p>Dataset report filter details</td>
<td class="whs8">
<p>{&amp;REPORTNAME:</p>
<p>REPORTFILTER</p>
<p>DETAILS}</td>
<td class="whs8">
<p>Report Filter:</p>
<p>Year = 2007</td>
<td class="whs8">
<p>The report filter used in the specified dataset report. </p>
<p>If you do not specify the report’s REPORTNAME as part of the code, the 
 filter information from the document's grouping and sorting dataset is 
 printed.</td></tr>

<tr valign="top" class="whs14">
<td class="whs7">
<p>Dataset report limit details</td>
<td class="whs8">
<p>{&amp;REPORTNAME:</p>
<p>REPORTLIMIT</p>
<p>DETAILS} </td>
<td class="whs8">
<p>Report Limits:</p>
<p>Revenue &gt; 2000000</td>
<td class="whs8">
<p>The report limit used in the specified dataset report.</p>
<p>If you do not specify the report’s REPORTNAME as part of the code, the 
 report limit information from the document's grouping and sorting dataset 
 is printed.</td></tr>

<tr valign="top" class="whs14">
<td class="whs7">
<p>Dataset report template details</td>
<td class="whs8">
<p>{&amp;REPORTNAME:</p>
<p>TEMPLATEDETAILS}</td>
<td class="whs8">
<p>Template: Region, Employee</p>
<p>Metrics: Revenue, Revenue {~+}, Cost, Sum(Cost){~+}, Profit, Sum(Profit){~+}</td>
<td class="whs8">
<p>The complete template details, including attribute details and metric 
 details. </p>
<p>You can define how this auto text code is displayed (for example, if 
 the template name is shown).</td></tr>

<tr valign="top" class="whs14">
<td class="whs7">
<p>Dataset report execution time</td>
<td class="whs8">
<p>{&amp;REPORTNAME: EXECUTIONTIME}</td>
<td class="whs8">
<p>11/15/2003 7:10:55 PM</td>
<td class="whs8">
<p>The date and time the dataset report was executed. An example is {&amp;[Sales 
 Forecast]: EXECUTIONTIME} for the Sales Forecast report.</td></tr>
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table></table><table>");
//--></script>
</table>
<p class="whs15">&nbsp;</p>
<p class="whs16">To format these codes, see 
<a href="Formatting_auto_text_codes.htm">About 
 formatting auto text codes</a>. You can format what is displayed (such 
 as whether to include view filter information) and how it is displayed 
 (such as whether to use a comma or the word <span class=Code>AND</span>.)</p>
<h3>Related topics</h3>
<ul type="disc" class="whs17">
	
<li class=p><p>
<a HREF="Add_auto_text_codes.htm">Adding auto text codes 
 to documents</a></p></li>
	
<li class=p><p>
<a HREF="Auto_text_codes_documents.htm">Auto text codes 
 for documents</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
